{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ‘PRD’及行业分析"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#  PRD1.数据加值宣言\n",
    "本项目产出以“PRD”为关键词，挖掘的关于 **猎聘网中各个行业**的工作数据，以解决“产品经理”就业需求及特性在各行业就业分析问题。\n",
    "\n",
    "* 关键词：PRD\n",
    "* 页数：所有（1-10）\n",
    "* 类别数据：学历、经验、薪水、时间、职称、公司地点、公司名称、链结、公司URL、所属行业\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# PRD2.MVP的数据加值\n",
    "产品核心价值：通过分析各行业的数据，总结“PRD”一职的基本要求与岗位需求，进而刻画产品经理的职业要求形象，为今后寻找产品经理的职位提供思考方向。\n",
    "\n",
    "通过产品经理应聘岗位的经验及薪水饼图，了解产品经理的经验分布和薪水分布，为想应征该岗位的人群提供相关数据及思考。"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Query参数设计\n",
    "\n",
    "keyword：PRD\n",
    "\n",
    "industries：行业\n",
    "\n",
    "curPage：页码"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 执行代码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:24.451231Z",
     "start_time": "2020-04-26T15:00:22.795871Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from requests_html import HTMLSession\n",
    "from urllib.parse import urlparse, parse_qs\n",
    "from IPython.display import display, HTML\n",
    "url = \"https://www.liepin.com/zhaopin/?keyword=PRD\"\n",
    "session = HTMLSession()\n",
    "r = session.get( url )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 获取行业数据选择器链接"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:25.580064Z",
     "start_time": "2020-04-26T15:00:25.364746Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'互联网/电商': '/zhaopin/?subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=040&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '游戏产业': '/zhaopin/?subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=420&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '计算机软件': '/zhaopin/?subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=010&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " 'IT服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=030&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '电子/芯片/半导体': '/zhaopin/?subIndustry=&init=-1&industryType=industry_02&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=050&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '通信业': '/zhaopin/?subIndustry=&init=-1&industryType=industry_02&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=060&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '计算机/网络设备': '/zhaopin/?subIndustry=&init=-1&industryType=industry_02&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=020&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '房地产/建筑': '/zhaopin/?subIndustry=&init=-1&industryType=industry_03&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=080&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '规划/设计/装潢': '/zhaopin/?subIndustry=&init=-1&industryType=industry_03&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=100&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '房地产服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_03&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=090&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '银行': '/zhaopin/?subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=130&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '保险': '/zhaopin/?subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=140&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '基金/证券/投资': '/zhaopin/?subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=150&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '会计/审计': '/zhaopin/?subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=430&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '信托/担保/拍卖': '/zhaopin/?subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=500&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '快消品': '/zhaopin/?subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=190&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '批发零售': '/zhaopin/?subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=240&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '服装纺织': '/zhaopin/?subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=200&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '家具/家电': '/zhaopin/?subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=210&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '办公设备': '/zhaopin/?subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=220&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '奢侈品/收藏品': '/zhaopin/?subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=460&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '珠宝/玩具/工艺品': '/zhaopin/?subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=470&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '汽车/摩托车': '/zhaopin/?subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=350&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '机械/机电/重工': '/zhaopin/?subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=360&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '印刷/包装/造纸': '/zhaopin/?subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=180&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '原材料加工': '/zhaopin/?subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=370&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '仪器/电气/自动化': '/zhaopin/?subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=340&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '制药/生物工程': '/zhaopin/?subIndustry=&init=-1&industryType=industry_10&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=270&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '医疗/保健/美容': '/zhaopin/?subIndustry=&init=-1&industryType=industry_10&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=280&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '医疗器械': '/zhaopin/?subIndustry=&init=-1&industryType=industry_10&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=290&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '能源/水利': '/zhaopin/?subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=330&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '石油/化工': '/zhaopin/?subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=310&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '采掘/冶炼/矿产': '/zhaopin/?subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=320&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '环保': '/zhaopin/?subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=300&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '新能源': '/zhaopin/?subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=490&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '专业服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=120&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '中介服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=110&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '外包服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=440&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '检测/认证': '/zhaopin/?subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=450&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '餐饮/酒旅/服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=230&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '文体娱乐': '/zhaopin/?subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=260&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '租赁服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=510&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '广告/市场/会展': '/zhaopin/?subIndustry=&init=-1&industryType=industry_08&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=070&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '影视文化': '/zhaopin/?subIndustry=&init=-1&industryType=industry_08&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=170&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '教育培训': '/zhaopin/?subIndustry=&init=-1&industryType=industry_08&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=380&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '交通/物流/运输': '/zhaopin/?subIndustry=&init=-1&industryType=industry_09&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=250&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '贸易/进出口': '/zhaopin/?subIndustry=&init=-1&industryType=industry_09&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=160&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '航空/航天': '/zhaopin/?subIndustry=&init=-1&industryType=industry_09&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=480&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '政务/公共服务': '/zhaopin/?subIndustry=&init=-1&industryType=industry_12&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=390&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '农林牧渔': '/zhaopin/?subIndustry=&init=-1&industryType=industry_12&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=410&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733',\n",
       " '其他行业': '/zhaopin/?subIndustry=&init=-1&industryType=industry_12&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=400&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733'}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "行业数据选择器链结 = r.html.xpath('//div[@data-selector=\"search-conditions\"]')[0] \\\n",
    "                    .xpath('//dt[@class=\"search-title\"]/following-sibling::dd')[1] \\\n",
    "                    .xpath('//div[contains(@class,\"sub-industry\")]/a/@href')\n",
    "行业数据选择器链结\n",
    "\n",
    "# 但我们需要知道这些选择器链结, 对映到什麽数据\n",
    "行业数据选择器链结 = r.html.xpath('//div[@data-selector=\"search-conditions\"]')[0] \\\n",
    "                    .xpath('//dt[@class=\"search-title\"]/following-sibling::dd')[1] \\\n",
    "                    .xpath('//div[contains(@class,\"sub-industry\")]/a')\n",
    "行业数据选择器链结\n",
    "\n",
    "#[ x.xpath(\"a/@href\")[0] for x in 公司数据选择器链结]\n",
    "#[ x.xpath(\"a/text()\")[0] for x in 公司数据选择器链结]\n",
    "行业数据选择器链结 = { x.xpath(\"a/text()\")[0]:x.xpath(\"a/@href\")[0] for x in 行业数据选择器链结}\n",
    "行业数据选择器链结\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 解析url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:25.738717Z",
     "start_time": "2020-04-26T15:00:25.732732Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=040&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=420&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=010&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_01&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=030&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_02&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=050&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_02&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=060&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_02&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=020&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_03&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=080&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_03&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=100&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_03&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=090&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=130&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=140&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=150&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=430&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_04&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=500&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=190&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=240&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=200&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=210&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=220&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=460&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_05&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=470&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=350&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=360&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=180&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=370&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_06&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=340&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_10&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=270&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_10&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=280&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_10&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=290&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=330&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=310&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=320&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=300&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_11&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=490&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=120&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=110&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=440&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=450&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=230&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=260&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_07&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=510&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_08&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=070&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_08&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=170&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_08&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=380&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_09&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=250&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_09&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=160&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_09&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=480&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_12&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=390&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_12&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=410&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='subIndustry=&init=-1&industryType=industry_12&headckid=8e82a7dae7110b1a&flushckid=1&fromSearchBtn=2&industries=400&keyword=PRD&ckid=8e82a7dae7110b1a&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=49aa0e148e76e460ce414c30517b1733&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733', fragment='')]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from urllib.parse import urlparse, parse_qs\n",
    "[ urlparse(x) for x in 行业数据选择器链结.values()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:25.945969Z",
     "start_time": "2020-04-26T15:00:25.919032Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scheme       1\n",
      "netloc       1\n",
      "path         1\n",
      "params       1\n",
      "query       51\n",
      "fragment     1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>subIndustry=&amp;init=-1&amp;industryType=industry_01&amp;...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  subIndustry=&init=-1&industryType=industry_01&...           "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame([ urlparse(x) for x in 行业数据选择器链结.values()])\n",
    "# df.info()\n",
    "print(df.nunique())\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:26.295753Z",
     "start_time": "2020-04-26T15:00:26.233367Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "init              1\n",
      "industryType     12\n",
      "headckid          1\n",
      "flushckid         1\n",
      "fromSearchBtn     1\n",
      "industries       51\n",
      "keyword           1\n",
      "ckid              1\n",
      "siTag             1\n",
      "d_sfrom           1\n",
      "d_ckId            1\n",
      "d_curPage         1\n",
      "d_pageSize        1\n",
      "d_headId          1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>keyword</th>\n",
       "      <th>industries</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PRD</td>\n",
       "      <td>040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PRD</td>\n",
       "      <td>420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PRD</td>\n",
       "      <td>010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PRD</td>\n",
       "      <td>030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PRD</td>\n",
       "      <td>050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PRD</td>\n",
       "      <td>060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PRD</td>\n",
       "      <td>020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PRD</td>\n",
       "      <td>080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PRD</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PRD</td>\n",
       "      <td>090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PRD</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PRD</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PRD</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PRD</td>\n",
       "      <td>430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>PRD</td>\n",
       "      <td>500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PRD</td>\n",
       "      <td>190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PRD</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PRD</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PRD</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PRD</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PRD</td>\n",
       "      <td>460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PRD</td>\n",
       "      <td>470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PRD</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PRD</td>\n",
       "      <td>360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PRD</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PRD</td>\n",
       "      <td>370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>PRD</td>\n",
       "      <td>340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>PRD</td>\n",
       "      <td>270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>PRD</td>\n",
       "      <td>280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>PRD</td>\n",
       "      <td>290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>PRD</td>\n",
       "      <td>330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>PRD</td>\n",
       "      <td>310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>PRD</td>\n",
       "      <td>320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>PRD</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>PRD</td>\n",
       "      <td>490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>PRD</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>PRD</td>\n",
       "      <td>110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>PRD</td>\n",
       "      <td>440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>PRD</td>\n",
       "      <td>450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>PRD</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PRD</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PRD</td>\n",
       "      <td>510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>PRD</td>\n",
       "      <td>070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>PRD</td>\n",
       "      <td>170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>PRD</td>\n",
       "      <td>380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>PRD</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>PRD</td>\n",
       "      <td>160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>PRD</td>\n",
       "      <td>480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>PRD</td>\n",
       "      <td>390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>PRD</td>\n",
       "      <td>410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>PRD</td>\n",
       "      <td>400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   keyword industries\n",
       "0      PRD        040\n",
       "1      PRD        420\n",
       "2      PRD        010\n",
       "3      PRD        030\n",
       "4      PRD        050\n",
       "5      PRD        060\n",
       "6      PRD        020\n",
       "7      PRD        080\n",
       "8      PRD        100\n",
       "9      PRD        090\n",
       "10     PRD        130\n",
       "11     PRD        140\n",
       "12     PRD        150\n",
       "13     PRD        430\n",
       "14     PRD        500\n",
       "15     PRD        190\n",
       "16     PRD        240\n",
       "17     PRD        200\n",
       "18     PRD        210\n",
       "19     PRD        220\n",
       "20     PRD        460\n",
       "21     PRD        470\n",
       "22     PRD        350\n",
       "23     PRD        360\n",
       "24     PRD        180\n",
       "25     PRD        370\n",
       "26     PRD        340\n",
       "27     PRD        270\n",
       "28     PRD        280\n",
       "29     PRD        290\n",
       "30     PRD        330\n",
       "31     PRD        310\n",
       "32     PRD        320\n",
       "33     PRD        300\n",
       "34     PRD        490\n",
       "35     PRD        120\n",
       "36     PRD        110\n",
       "37     PRD        440\n",
       "38     PRD        450\n",
       "39     PRD        230\n",
       "40     PRD        260\n",
       "41     PRD        510\n",
       "42     PRD        070\n",
       "43     PRD        170\n",
       "44     PRD        380\n",
       "45     PRD        250\n",
       "46     PRD        160\n",
       "47     PRD        480\n",
       "48     PRD        390\n",
       "49     PRD        410\n",
       "50     PRD        400"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df_qs = pd.DataFrame([ parse_qs(x) for x in df['query'] ])\n",
    "# df_qs\n",
    "\n",
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "print (df_qs.nunique())\n",
    "df_qs.head()\n",
    "df_qs[['keyword','industries']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:26.433514Z",
     "start_time": "2020-04-26T15:00:26.408228Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'init': '-1', 'industryType': 'industry_01', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '040', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_01', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '420', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_01', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '010', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_01', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '030', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_02', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '050', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_02', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '060', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_02', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '020', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_03', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '080', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_03', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '100', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_03', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '090', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_04', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '130', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_04', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '140', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_04', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '150', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_04', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '430', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_04', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '500', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_05', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '190', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_05', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '240', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_05', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '200', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_05', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '210', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_05', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '220', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_05', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '460', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_05', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '470', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_06', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '350', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_06', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '360', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_06', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '180', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_06', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '370', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_06', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '340', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_10', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '270', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_10', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '280', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_10', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '290', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_11', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '330', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_11', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '310', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_11', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '320', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_11', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '300', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_11', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '490', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_07', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '120', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_07', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '110', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_07', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '440', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_07', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '450', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_07', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '230', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_07', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '260', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_07', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '510', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_08', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '070', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_08', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '170', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_08', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '380', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_09', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '250', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_09', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '160', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_09', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '480', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_12', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '390', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_12', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '410', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}, {'init': '-1', 'industryType': 'industry_12', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '400', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}] {'init': '-1', 'industryType': 'industry_12', 'headckid': '8e82a7dae7110b1a', 'flushckid': '1', 'fromSearchBtn': '2', 'industries': '400', 'keyword': 'PRD', 'ckid': '8e82a7dae7110b1a', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '49aa0e148e76e460ce414c30517b1733', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '49aa0e148e76e460ce414c30517b1733'}\n"
     ]
    }
   ],
   "source": [
    "列表暂存 = [] # list()\n",
    "for x in df['query']: \n",
    "    列表暂存.append({k:v[0] for k,v in parse_qs(x).items()} )\n",
    "    \n",
    "# ----------------------------------------------\n",
    "# 字典暂存 = {k:v[0] for k,v in parse_qs(x).items()}\n",
    "# 以下3行代碼相當於上面推導1行\n",
    "字典暂存 = dict()\n",
    "for k,v in parse_qs(x).items():     # for 键,值 in 字典.items():\n",
    "    字典暂存.update({k:v[0]})\n",
    "    \n",
    "# ----------------------------------------------\n",
    "print (列表暂存, 字典暂存) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:26.598491Z",
     "start_time": "2020-04-26T15:00:26.574514Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'init': '-1',\n",
       "  'industryType': 'industry_01',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '040',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_01',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '420',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_01',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '010',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_01',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '030',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_02',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '050',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_02',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '060',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_02',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '020',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_03',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '080',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_03',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '100',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_03',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '090',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_04',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '130',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_04',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '140',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_04',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '150',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_04',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '430',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_04',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '500',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_05',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '190',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_05',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '240',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_05',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '200',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_05',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '210',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_05',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '220',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_05',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '460',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_05',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '470',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_06',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '350',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_06',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '360',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_06',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '180',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_06',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '370',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_06',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '340',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_10',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '270',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_10',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '280',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_10',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '290',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_11',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '330',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_11',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '310',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_11',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '320',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_11',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '300',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_11',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '490',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_07',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '120',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_07',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '110',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_07',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '440',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_07',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '450',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_07',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '230',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_07',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '260',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_07',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '510',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_08',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '070',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_08',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '170',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_08',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '380',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_09',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '250',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_09',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '160',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_09',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '480',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_12',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '390',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_12',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '410',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'},\n",
       " {'init': '-1',\n",
       "  'industryType': 'industry_12',\n",
       "  'headckid': '8e82a7dae7110b1a',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'industries': '400',\n",
       "  'keyword': 'PRD',\n",
       "  'ckid': '8e82a7dae7110b1a',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '49aa0e148e76e460ce414c30517b1733',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '49aa0e148e76e460ce414c30517b1733'}]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "列表暫存 = [] # list()\n",
    "for q in df['query']: \n",
    "    字典暫存 = dict()\n",
    "    for k,v in parse_qs(q).items(): # for 鍵,值 in 字典.items():\n",
    "        字典暫存.update({k:v[0]})\n",
    "    列表暫存.append(字典暫存)\n",
    "列表暫存"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 建构 参数模板 及 字典_industries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:26.975359Z",
     "start_time": "2020-04-26T15:00:26.941881Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['040'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}\n",
      "{'互联网/电商': '040', '游戏产业': '420', '计算机软件': '010', 'IT服务': '030', '电子/芯片/半导体': '050', '通信业': '060', '计算机/网络设备': '020', '房地产/建筑': '080', '规划/设计/装潢': '100', '房地产服务': '090', '银行': '130', '保险': '140', '基金/证券/投资': '150', '会计/审计': '430', '信托/担保/拍卖': '500', '快消品': '190', '批发零售': '240', '服装纺织': '200', '家具/家电': '210', '办公设备': '220', '奢侈品/收藏品': '460', '珠宝/玩具/工艺品': '470', '汽车/摩托车': '350', '机械/机电/重工': '360', '印刷/包装/造纸': '180', '原材料加工': '370', '仪器/电气/自动化': '340', '制药/生物工程': '270', '医疗/保健/美容': '280', '医疗器械': '290', '能源/水利': '330', '石油/化工': '310', '采掘/冶炼/矿产': '320', '环保': '300', '新能源': '490', '专业服务': '120', '中介服务': '110', '外包服务': '440', '检测/认证': '450', '餐饮/酒旅/服务': '230', '文体娱乐': '260', '租赁服务': '510', '广告/市场/会展': '070', '影视文化': '170', '教育培训': '380', '交通/物流/运输': '250', '贸易/进出口': '160', '航空/航天': '480', '政务/公共服务': '390', '农林牧渔': '410', '其他行业': '400'}\n"
     ]
    }
   ],
   "source": [
    "\n",
    "def parse_url_qs_for_industries (url):\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "\n",
    "# parse_url_qs_for_industries(list(行业数据选择器链结.values())[0])['industries']\n",
    "参数模板 = parse_url_qs_for_industries(list(行业数据选择器链结.values())[0])\n",
    "print(参数模板)\n",
    "# [ parse_url_qs_for_industries(x)['industries'] for x in 行业数据选择器链结.values()]\n",
    "[ parse_url_qs_for_industries(x)['industries'][0] for x in 行业数据选择器链结.values()]\n",
    "\n",
    "字典_industries = { k:parse_url_qs_for_industries(v)['industries'][0] for k,v in 行业数据选择器链结.items()}\n",
    "print (字典_industries)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 建构 参数模板  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:27.286834Z",
     "start_time": "2020-04-26T15:00:27.281059Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'互联网/电商': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['040'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '游戏产业': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['420'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '计算机软件': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['010'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, 'IT服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['030'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '电子/芯片/半导体': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['050'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '通信业': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['060'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '计算机/网络设备': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['020'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '房地产/建筑': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['080'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '规划/设计/装潢': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['100'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '房地产服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['090'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '银行': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['130'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '保险': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['140'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '基金/证券/投资': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['150'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '会计/审计': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['430'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '信托/担保/拍卖': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['500'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '快消品': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['190'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '批发零售': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['240'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '服装纺织': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['200'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '家具/家电': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['210'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '办公设备': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['220'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '奢侈品/收藏品': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['460'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '珠宝/玩具/工艺品': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['470'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '汽车/摩托车': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['350'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '机械/机电/重工': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['360'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '印刷/包装/造纸': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['180'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '原材料加工': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['370'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '仪器/电气/自动化': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['340'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '制药/生物工程': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['270'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '医疗/保健/美容': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['280'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '医疗器械': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['290'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '能源/水利': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['330'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '石油/化工': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['310'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '采掘/冶炼/矿产': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['320'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '环保': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['300'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '新能源': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['490'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '专业服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['120'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '中介服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['110'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '外包服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['440'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '检测/认证': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['450'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '餐饮/酒旅/服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['230'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '文体娱乐': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['260'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '租赁服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['510'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '广告/市场/会展': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['070'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '影视文化': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['170'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '教育培训': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['380'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '交通/物流/运输': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['250'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '贸易/进出口': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['160'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '航空/航天': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['480'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '政务/公共服务': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['390'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '农林牧渔': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['410'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}, '其他行业': {'init': ['-1'], 'industryType': ['industry_01'], 'headckid': ['8e82a7dae7110b1a'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'industries': ['400'], 'keyword': ['PRD'], 'ckid': ['8e82a7dae7110b1a'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['49aa0e148e76e460ce414c30517b1733'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733']}}\n"
     ]
    }
   ],
   "source": [
    "# 建构 参数模板  \n",
    "def 参数模板生成(industries , keyword ):\n",
    "    参数 = 参数模板.copy()\n",
    "    参数['industries'] = industries\n",
    "    参数['keyword'] = keyword\n",
    "    return (参数)\n",
    "\n",
    "参数_industries_PRD = { k:参数模板生成(industries = [v], keyword = ['PRD']) for k,v in 字典_industries.items()}\n",
    "print(参数_industries_PRD)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:57.955579Z",
     "start_time": "2020-04-26T15:00:27.483557Z"
    }
   },
   "outputs": [],
   "source": [
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "session = HTMLSession()\n",
    "payload = 参数_industries_PRD['互联网/电商']\n",
    "r = session.get( url, params = payload)\n",
    "\n",
    "r.url\n",
    "\n",
    "session = HTMLSession()\n",
    "\n",
    "def requests_liepin( url, params):\n",
    "    r = session.get( url , params = payload)\n",
    "\n",
    "    # 先取特定元素, 精准打击其子后辈\n",
    "    主要元素 = r.html.xpath( '//ul[@class=\"sojob-list\"]/li')\n",
    "\n",
    "    # 作为xpath字典，键为我要抓的牛肉名称，值为xpath\n",
    "    dict_xpaths={ \n",
    "        'text': {\n",
    "            'edu':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]',\n",
    "            '经验':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]/following-sibling::span',\n",
    "            '薪水':    '//div[contains(@class,\"job-info\")]/p/span[@class=\"text-warning\"]', \n",
    "            '时间':    '//div[contains(@class,\"job-info\")]/p/time/@title', \n",
    "            '职称':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司地点': '//div[contains(@class,\"job-info\")]/p/a',\n",
    "            '公司名称': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        },\n",
    "        'text_content': {\n",
    "        },\n",
    "        'href': {\n",
    "            '链结':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司URL': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        }\n",
    "    }\n",
    "\n",
    "    def get_e_text_content(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [e.xpath(_xpath_)[0].lxml.text_content() for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_text(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [\"\".join([x.strip() if type(x) is str else x.text.strip() for x in e.xpath(_xpath_)]) for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_href(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [list(e.xpath(_xpath_, first=True).absolute_links)[0] \\\n",
    "                   if len(e.xpath(_xpath_, first=True).absolute_links) >= 1  \\\n",
    "                   else \"\" for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    # 只对主要元素下进行.xpath取值\n",
    "    数据字典 = dict()\n",
    "\n",
    "    数据字典 = {k:get_e_text_content(v) for k,v in dict_xpaths['text_content'].items()}\n",
    "    数据字典.update({k:get_e_text(v) for k,v in dict_xpaths['text'].items()})\n",
    "    数据字典.update({k:get_e_href(v) for k,v in dict_xpaths['href'].items()})\n",
    "\n",
    "    数据 = pd.DataFrame(数据字典)\n",
    "    #数据.to_excel(\"20春_Web数据挖掘_week03_liepin.xlsx\", sheet_name=\"搜查结果\")\n",
    "    return (数据)\n",
    "\n",
    "\n",
    "# 上周C-3   多个页面\n",
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "\n",
    "list_df = list()\n",
    "for k,v in 参数_industries_PRD.items():\n",
    "    payload = v\n",
    "    df = requests_liepin( url, params = payload)\n",
    "    df = df.assign (行业类型 = k)    \n",
    "    list_df.append(df)\n",
    "\n",
    "df_all = pd.concat(list_df)\n",
    "df_all\n",
    "\n",
    "# 上周C-4   输出\n",
    "df_all.to_excel(\"20春_Web数据挖掘_week06_liepin_行业类型.xlsx\", sheet_name=\"搜查结果\")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 多页数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:58.083634Z",
     "start_time": "2020-04-26T15:00:57.957312Z"
    },
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# xpath 解析翻页a/@href\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a' # 有disabled, current等href是javascript\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a[starts-with(@href,\"/zhaopin\")]'\n",
    "# print (r.html.xpath(xpath_翻页a)) # 物件\n",
    "\n",
    "href_列表 = [x.xpath('//@href')[0] for x in r.html.xpath(xpath_翻页a)]\n",
    "#print (href_列表)\n",
    "\n",
    "文字_列表 = [x.text for x in r.html.xpath(xpath_翻页a)]\n",
    "#print (文字_列表)\n",
    "\n",
    "href_字典 = {x.text:x.xpath('//@href')[0]  for x in r.html.xpath(xpath_翻页a)}\n",
    "# print (href_字典)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:58.116182Z",
     "start_time": "2020-04-26T15:00:58.085198Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=8e82a7dae7110b1a&amp;fromSearchBt...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=8e82a7dae7110b1a&amp;fromSearchBt...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=8e82a7dae7110b1a&amp;fromSearchBt...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=8e82a7dae7110b1a&amp;fromSearchBt...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=8e82a7dae7110b1a&amp;fromSearchBt...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=8e82a7dae7110b1a&amp;fromSearchBt...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "1                /zhaopin/          \n",
       "2                /zhaopin/          \n",
       "3                /zhaopin/          \n",
       "4                /zhaopin/          \n",
       "5                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  init=-1&headckid=8e82a7dae7110b1a&fromSearchBt...           \n",
       "1  init=-1&headckid=8e82a7dae7110b1a&fromSearchBt...           \n",
       "2  init=-1&headckid=8e82a7dae7110b1a&fromSearchBt...           \n",
       "3  init=-1&headckid=8e82a7dae7110b1a&fromSearchBt...           \n",
       "4  init=-1&headckid=8e82a7dae7110b1a&fromSearchBt...           \n",
       "5  init=-1&headckid=8e82a7dae7110b1a&fromSearchBt...           "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scheme      1\n",
      "netloc      1\n",
      "path        1\n",
      "params      1\n",
      "query       5\n",
      "fragment    1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>init</th>\n",
       "      <th>headckid</th>\n",
       "      <th>fromSearchBtn</th>\n",
       "      <th>ckid</th>\n",
       "      <th>industryType</th>\n",
       "      <th>industries</th>\n",
       "      <th>keyword</th>\n",
       "      <th>siTag</th>\n",
       "      <th>d_sfrom</th>\n",
       "      <th>d_ckId</th>\n",
       "      <th>d_curPage</th>\n",
       "      <th>d_pageSize</th>\n",
       "      <th>d_headId</th>\n",
       "      <th>curPage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-1</td>\n",
       "      <td>8e82a7dae7110b1a</td>\n",
       "      <td>2</td>\n",
       "      <td>22bb8b2cbbae3ebe°radeFlag=0</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>PRD</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>abec528a47e5bccf52c3ee9252cd78c4</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>49aa0e148e76e460ce414c30517b1733</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-1</td>\n",
       "      <td>8e82a7dae7110b1a</td>\n",
       "      <td>2</td>\n",
       "      <td>22bb8b2cbbae3ebe°radeFlag=0</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>PRD</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>abec528a47e5bccf52c3ee9252cd78c4</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>49aa0e148e76e460ce414c30517b1733</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-1</td>\n",
       "      <td>8e82a7dae7110b1a</td>\n",
       "      <td>2</td>\n",
       "      <td>22bb8b2cbbae3ebe°radeFlag=0</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>PRD</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>abec528a47e5bccf52c3ee9252cd78c4</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>49aa0e148e76e460ce414c30517b1733</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-1</td>\n",
       "      <td>8e82a7dae7110b1a</td>\n",
       "      <td>2</td>\n",
       "      <td>22bb8b2cbbae3ebe°radeFlag=0</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>PRD</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>abec528a47e5bccf52c3ee9252cd78c4</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>49aa0e148e76e460ce414c30517b1733</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-1</td>\n",
       "      <td>8e82a7dae7110b1a</td>\n",
       "      <td>2</td>\n",
       "      <td>22bb8b2cbbae3ebe°radeFlag=0</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>PRD</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>abec528a47e5bccf52c3ee9252cd78c4</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>49aa0e148e76e460ce414c30517b1733</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-1</td>\n",
       "      <td>8e82a7dae7110b1a</td>\n",
       "      <td>2</td>\n",
       "      <td>22bb8b2cbbae3ebe°radeFlag=0</td>\n",
       "      <td>industry_01</td>\n",
       "      <td>040</td>\n",
       "      <td>PRD</td>\n",
       "      <td>1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g</td>\n",
       "      <td>search_unknown</td>\n",
       "      <td>abec528a47e5bccf52c3ee9252cd78c4</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>49aa0e148e76e460ce414c30517b1733</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  init          headckid fromSearchBtn                         ckid  \\\n",
       "0   -1  8e82a7dae7110b1a             2  22bb8b2cbbae3ebe°radeFlag=0   \n",
       "1   -1  8e82a7dae7110b1a             2  22bb8b2cbbae3ebe°radeFlag=0   \n",
       "2   -1  8e82a7dae7110b1a             2  22bb8b2cbbae3ebe°radeFlag=0   \n",
       "3   -1  8e82a7dae7110b1a             2  22bb8b2cbbae3ebe°radeFlag=0   \n",
       "4   -1  8e82a7dae7110b1a             2  22bb8b2cbbae3ebe°radeFlag=0   \n",
       "5   -1  8e82a7dae7110b1a             2  22bb8b2cbbae3ebe°radeFlag=0   \n",
       "\n",
       "  industryType industries keyword  \\\n",
       "0  industry_01        040     PRD   \n",
       "1  industry_01        040     PRD   \n",
       "2  industry_01        040     PRD   \n",
       "3  industry_01        040     PRD   \n",
       "4  industry_01        040     PRD   \n",
       "5  industry_01        040     PRD   \n",
       "\n",
       "                                           siTag         d_sfrom  \\\n",
       "0  1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g  search_unknown   \n",
       "1  1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g  search_unknown   \n",
       "2  1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g  search_unknown   \n",
       "3  1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g  search_unknown   \n",
       "4  1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g  search_unknown   \n",
       "5  1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g  search_unknown   \n",
       "\n",
       "                             d_ckId d_curPage d_pageSize  \\\n",
       "0  abec528a47e5bccf52c3ee9252cd78c4         0         40   \n",
       "1  abec528a47e5bccf52c3ee9252cd78c4         0         40   \n",
       "2  abec528a47e5bccf52c3ee9252cd78c4         0         40   \n",
       "3  abec528a47e5bccf52c3ee9252cd78c4         0         40   \n",
       "4  abec528a47e5bccf52c3ee9252cd78c4         0         40   \n",
       "5  abec528a47e5bccf52c3ee9252cd78c4         0         40   \n",
       "\n",
       "                           d_headId curPage  \n",
       "0  49aa0e148e76e460ce414c30517b1733       1  \n",
       "1  49aa0e148e76e460ce414c30517b1733       2  \n",
       "2  49aa0e148e76e460ce414c30517b1733       3  \n",
       "3  49aa0e148e76e460ce414c30517b1733       4  \n",
       "4  49aa0e148e76e460ce414c30517b1733       1  \n",
       "5  49aa0e148e76e460ce414c30517b1733       9  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "init             1\n",
      "headckid         1\n",
      "fromSearchBtn    1\n",
      "ckid             1\n",
      "industryType     1\n",
      "industries       1\n",
      "keyword          1\n",
      "siTag            1\n",
      "d_sfrom          1\n",
      "d_ckId           1\n",
      "d_curPage        1\n",
      "d_pageSize       1\n",
      "d_headId         1\n",
      "curPage          5\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# 总体目标：输入 href_列表, 建构出参数字典\n",
    "\n",
    "# urlparse 解析后丢入数据框\n",
    "df = pd.DataFrame([ urlparse(x) for x in href_列表])\n",
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "\n",
    "display(df)\n",
    "print(df.nunique())\n",
    "display(df_qs)\n",
    "print(df_qs.nunique())\n",
    "\n",
    "df_qs.curPage\n",
    "df_qs = df_qs.assign (curPage_int=df_qs.curPage.astype(int)) # 变成整数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:58.122100Z",
     "start_time": "2020-04-26T15:00:58.117112Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'init': ['-1'], 'headckid': ['8e82a7dae7110b1a'], 'fromSearchBtn': ['2'], 'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'], 'industryType': ['industry_01'], 'industries': ['040'], 'keyword': ['PRD'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['49aa0e148e76e460ce414c30517b1733'], 'curPage': ['1']}\n",
      "{'2': '/zhaopin/?init=-1&headckid=8e82a7dae7110b1a&fromSearchBtn=2&ckid=22bb8b2cbbae3ebe°radeFlag=0&industryType=industry_01&industries=040&keyword=PRD&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7E1p1Hf6Iytm4nd3ac31P45g&d_sfrom=search_unknown&d_ckId=abec528a47e5bccf52c3ee9252cd78c4&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733&curPage=1', '3': '/zhaopin/?init=-1&headckid=8e82a7dae7110b1a&fromSearchBtn=2&ckid=22bb8b2cbbae3ebe°radeFlag=0&industryType=industry_01&industries=040&keyword=PRD&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7E1p1Hf6Iytm4nd3ac31P45g&d_sfrom=search_unknown&d_ckId=abec528a47e5bccf52c3ee9252cd78c4&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733&curPage=2', '4': '/zhaopin/?init=-1&headckid=8e82a7dae7110b1a&fromSearchBtn=2&ckid=22bb8b2cbbae3ebe°radeFlag=0&industryType=industry_01&industries=040&keyword=PRD&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7E1p1Hf6Iytm4nd3ac31P45g&d_sfrom=search_unknown&d_ckId=abec528a47e5bccf52c3ee9252cd78c4&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733&curPage=3', '5': '/zhaopin/?init=-1&headckid=8e82a7dae7110b1a&fromSearchBtn=2&ckid=22bb8b2cbbae3ebe°radeFlag=0&industryType=industry_01&industries=040&keyword=PRD&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7E1p1Hf6Iytm4nd3ac31P45g&d_sfrom=search_unknown&d_ckId=abec528a47e5bccf52c3ee9252cd78c4&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733&curPage=4', '下一页': '/zhaopin/?init=-1&headckid=8e82a7dae7110b1a&fromSearchBtn=2&ckid=22bb8b2cbbae3ebe°radeFlag=0&industryType=industry_01&industries=040&keyword=PRD&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7E1p1Hf6Iytm4nd3ac31P45g&d_sfrom=search_unknown&d_ckId=abec528a47e5bccf52c3ee9252cd78c4&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733&curPage=1', '': '/zhaopin/?init=-1&headckid=8e82a7dae7110b1a&fromSearchBtn=2&ckid=22bb8b2cbbae3ebe°radeFlag=0&industryType=industry_01&industries=040&keyword=PRD&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7E1p1Hf6Iytm4nd3ac31P45g&d_sfrom=search_unknown&d_ckId=abec528a47e5bccf52c3ee9252cd78c4&d_curPage=0&d_pageSize=40&d_headId=49aa0e148e76e460ce414c30517b1733&curPage=9'}\n"
     ]
    }
   ],
   "source": [
    "# 建构参数模板：找到关键参数及参数结构\n",
    "\n",
    "def parse_url_qs_for_curPage (url):\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "\n",
    "# 取一例做模板\n",
    "参数模板 = parse_url_qs_for_curPage(href_列表[0])\n",
    "print (参数模板)\n",
    "\n",
    "print (href_字典)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:00:58.142069Z",
     "start_time": "2020-04-26T15:00:58.123096Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "9\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{0: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [0]},\n",
       " 1: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [1]},\n",
       " 2: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [2]},\n",
       " 3: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [3]},\n",
       " 4: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [4]},\n",
       " 5: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [5]},\n",
       " 6: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [6]},\n",
       " 7: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [7]},\n",
       " 8: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [8]},\n",
       " 9: {'init': ['-1'],\n",
       "  'headckid': ['8e82a7dae7110b1a'],\n",
       "  'fromSearchBtn': ['2'],\n",
       "  'ckid': ['22bb8b2cbbae3ebe°radeFlag=0'],\n",
       "  'industryType': ['industry_01'],\n",
       "  'industries': ['040'],\n",
       "  'keyword': ['PRD'],\n",
       "  'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~1p1Hf6Iytm4nd3ac31P45g'],\n",
       "  'd_sfrom': ['search_unknown'],\n",
       "  'd_ckId': ['abec528a47e5bccf52c3ee9252cd78c4'],\n",
       "  'd_curPage': ['0'],\n",
       "  'd_pageSize': ['40'],\n",
       "  'd_headId': ['49aa0e148e76e460ce414c30517b1733'],\n",
       "  'curPage': [9]}}"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 建构参数模板生成器：keyword curPage\n",
    "def 翻页参数模板生成(keyword, curPage):\n",
    "    参数 = 参数模板.copy()\n",
    "    参数['curPage'] = curPage\n",
    "    参数['keyword'] = keyword\n",
    "    return (参数)\n",
    "\n",
    "参数_keyword_PRD_curPage = { \n",
    "    i:翻页参数模板生成(curPage = [i], \\\n",
    "                  keyword = ['PRD']) \\\n",
    "    for i,v in href_字典.items()\\\n",
    "    }\n",
    "\n",
    "# print(参数_keyword_PRDcurPage) # 只生成本页有的额外翻页URL, 并没有推估到&curPage=9,也没有这页\n",
    "\n",
    "print (df_qs.curPage_int.min()) # 最小值只有1\n",
    "print (df_qs.curPage_int.max()) # 最大值只有9\n",
    "\n",
    "# 应该是 0 (本页)....9(最大值)\n",
    "\n",
    "参数_keyword_PRD_curPage = { \n",
    "    i:翻页参数模板生成(curPage = [i], \\\n",
    "                  keyword = ['PRD']) \\\n",
    "    for i in range(0,df_qs.curPage_int.max()+1)\\\n",
    "    }\n",
    "参数_keyword_PRD_curPage"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 多类别数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:09:46.423845Z",
     "start_time": "2020-04-26T15:09:41.901Z"
    }
   },
   "outputs": [],
   "source": [
    "import time\n",
    "from random import random\n",
    "\n",
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "xpath_翻页a = '//div[@class=\"pagerbar\"]/a[starts-with(@href,\"/zhaopin\")]'\n",
    "\n",
    "keywords = ['PRD','数据分析']\n",
    "list_df = list()\n",
    "\n",
    "## 第一页试探有多长的页面\n",
    "for key in keywords:\n",
    "    payload = 翻页参数模板生成(keyword=[key], curPage=['0'])\n",
    "    df = requests_liepin( url, params = payload)\n",
    "    href_列表 = [x.xpath('//@href')[0] for x in r.html.xpath(xpath_翻页a)]\n",
    "    df = pd.DataFrame([ urlparse(x) for x in href_列表])\n",
    "    df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "    df_qs = df_qs.assign (curPage_int=df_qs.curPage.astype(int)) # 变成整数\n",
    "    长度 = df_qs.curPage_int.max()+1\n",
    "    参数_keyword_X_curPage = { \n",
    "        i:翻页参数模板生成(curPage = [i], \\\n",
    "                      keyword = [key]) \\\n",
    "        for i in range(0,长度)\\\n",
    "        }\n",
    "    #print (参数_keyword_X_curPage)\n",
    "    print (key,长度)\n",
    "    \n",
    "    for k,v in 参数_keyword_X_curPage.items():\n",
    "        payload = v\n",
    "        df = requests_liepin( url, params = payload)\n",
    "        time.sleep(3+4*random())  #放慢脚步 3-7秒, 平均约5秒\n",
    "        df = df.assign (keyword = key)  # 区分  keyword    \n",
    "        df = df.assign (curPage = k)  # 区分  curPage    \n",
    "        list_df.append(df)\n",
    "        \n",
    "        for k,v in 参数_industries_PRD.items():\n",
    "            payload = v\n",
    "            df = requests_liepin( url, params = payload)\n",
    "            df = df.assign (行业类型 = k)    \n",
    "            list_df.append(df)\n",
    "        \n",
    "df_all = pd.concat(list_df).reset_index()\n",
    "df_all.index.name = '序列'\n",
    "\n",
    "df_all.to_excel(\"PRD_总.xlsx\",\\\n",
    "                sheet_name=\"_\".join(keywords))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:09:46.424854Z",
     "start_time": "2020-04-26T15:09:42.119Z"
    }
   },
   "outputs": [],
   "source": [
    "PRD_总=pd.read_excel('PRD_总.xlsx')\n",
    "PRD_总=数据分析_总.reset_index().rename(columns={'index':'序列','edu':'学历'})\n",
    "PRD_总"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 数据处理加值"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 经验饼图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:09:46.424854Z",
     "start_time": "2020-04-26T15:09:42.875Z"
    }
   },
   "outputs": [],
   "source": [
    "display(PRD_总['经验'].value_counts())\n",
    "PRD_总['经验'].value_counts().plot.pie()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 薪水饼图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-04-26T15:09:46.425843Z",
     "start_time": "2020-04-26T15:09:43.633Z"
    }
   },
   "outputs": [],
   "source": [
    "display(PRD_总['薪水'].describe())\n",
    "display(PRD_总['薪水'].value_counts())\n",
    "PRD_总['薪水'].value_counts().plot.pie()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.10"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
